More likely than not, a lot of people have visited a library and checked out a book. Whether it’s for school, work, or just for a personal read, people come in and out checking out various types of materials. You might wonder what other people like to read or what books are really popular at the given time so you can check it out. That’s what this data allows you to do. The data used for analysis is the Seattle Public Library’s checkout records for the 2022-2023 period. The dataset includes information about the material types, publication years, and checkout counts for a wide variety of books, movies, and other items available at the library.
This report aims to give a better understanding about the Colleen Hoover’s popularity and trends among Seattle Public Library patrons by analyzing checkout data from the 2022-2023 fiscal year. Three visualizations were created to showcase the data: a bar chart of the top 5 material types with the most checkouts for Colleen Hoover books, a line chart showing the checkout trends over time for Colleen Hoover, and a table showing the top 5 most checked out books by Colleen Hoover.
I chose to analyze these trends because Colleen Hoover has been a really popular author as of recently, I am also a huge fan of her work, and the interest in understanding how the publication year may affect the popularity of her books at the Seattle Public Library.
Based on the data for Colleen Hoover, we can conclude the following findings. The average number of checkouts for each material type is shown in the ‘avg_checkouts’ table, which suggests that ebooks have the highest average checkouts. The month with the most checkouts for the book ‘Verity’ by Colleen Hoover is January, while the month with the least checkouts is Feburary, as shown in the ‘max_month’ and ‘min_month’ tables. For Colleen Hoover, ebooks seem to be the more popular type to checkout. Lastly, the month with the most checkouts for ebooks for Colleen Hoover is January 2023, while the month with the least checkouts is January 2022, as shown in the ‘hoover_ebook_month’ table. This also shows us what I thought was to be true, Colleen Hoover is getting more attention in more recent times, more specifically, checkouts started to spike starting on September 2022.
The dataset is the 2022-2023 All Checkouts SPL Data, which contains information on checkout records from the Seattle Public Library system. The dataset was collected by the Seattle Public Library system and covers the period from January 2022 to present. The data includes information on the material type, publication year, creator, and checkout month for each checkout record.
The data was likely collected automatically by the library’s checkout system, which records the relevant information when a patron checks out a book. The purpose of collecting this data is likely to better understand library usage patterns and to inform decision-making related to library operations and services.
When working with this data, there are several ethical considerations to keep in mind. Firstly, the data contains personal information about library patrons, such as their borrowing history and potentially their reading preferences. It is important to ensure that this data is handled securely and that patron privacy is respected. Additionally, there may be biases in the data, such as over-representation of certain kinds of books or authors, that could impact any analyses conducted using the data.
One potential limitation of the data is that it only includes checkout records from a single library system in a specific geographic location. This could limit the generalizability of any findings to other library systems or to patrons in other locations. Additionally, the data may be limited by the accuracy of the information recorded by the checkout system, which could vary depending on factors such as user error or system malfunctions.
This line graph compares the total number of checkouts over time for James Patterson and Colleen Hoover.
This line plot shows the checkout trends over time for the top 5 most checked out books by Colleen Hoover.
This bar plot shows the top 5 material types with the most checkouts for Colleen Hoover.